﻿CREATE PROCEDURE [dbo].[ReportOvertime]
@BeginDate DATETIME, @EndDate DATETIME
AS
BEGIN
	SELECT FullName, EntryDate, Duration, DATEPART(week, EntryDate) AS Week
	FROM  dbo.vwInvoices
	WHERE (EntryDate >= @BeginDate) AND (EntryDate <= @EndDate) AND (ProjectType = 'Time & Materials')
	ORDER BY FullName, EntryDate
END

